Computer and Modernization ›› 2013, Vol. 218 ›› Issue (10): 91-93.doi: 10.3969/j.issn.1006-2475.2013.10.023

• 数据库 • Previous Articles     Next Articles

Application of Data Granularity in Warehouse for E-commerce Website

QI Li-na   

  1. Department of Computer Teaching, Shanghai Commercial Accounting School, Shanghai 200011, China
  • Received:2013-05-17 Revised:1900-01-01 Online:2013-10-26 Published:2013-10-26

Abstract: Data granularity decides the amount of data in data warehouse and the ability to answer queries. Multiple-granularity can not only satisfy the requirements of the amount of data to a certain extent, but also meet the requirements of the ability to answer queries. So in the design of data warehouse, multiple-granularity becomes the preferred. When the data warehouse using multiple-granularity, we will face with how to manage data-granularity problem. This paper firstly studies granularity level and multiple-granularity, puts forward granularity table in order to manage data granularity, expounds the definition process of granularity table, analyzes the advantages of granularity table; and puts forward the process of data warehouse multi-dimensional model based on granularity table.

Key words: data warehouse multi-dimensional model, data granularity, granularity level, multiple-granularity, granularity table

CLC Number: